package registnet.dao;

import java.math.BigDecimal;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Date;
import java.util.Iterator;
import java.util.LinkedList;
import java.util.List;

import org.apache.torque.NoRowsException;
import org.apache.torque.TooManyRowsException;
import org.apache.torque.Torque;
import org.apache.torque.TorqueException;
import org.apache.torque.map.MapBuilder;
import org.apache.torque.map.TableMap;
import org.apache.torque.om.DateKey;
import org.apache.torque.om.NumberKey;
import org.apache.torque.om.StringKey;
import org.apache.torque.om.ObjectKey;
import org.apache.torque.om.SimpleKey;
import org.apache.torque.util.BasePeer;
import org.apache.torque.util.Criteria;

import com.workingdogs.village.DataSetException;
import com.workingdogs.village.QueryDataSet;
import com.workingdogs.village.Record;

// Local classes
import registnet.dao.map.*;


/**
 * This class was autogenerated by Torque on:
 *
 * [Tue Jun 30 14:38:16 PDT 2009]
 *
 */
public abstract class BaseStudentLogPeer
    extends BasePeer
{

    /** the default database name for this class */
    public static final String DATABASE_NAME = "RegistNetDB";

     /** the table name for this class */
    public static final String TABLE_NAME = "student_log";

    /**
     * @return the map builder for this peer
     * @throws TorqueException Any exceptions caught during processing will be
     *         rethrown wrapped into a TorqueException.
     */
    public static MapBuilder getMapBuilder()
        throws TorqueException
    {
        return getMapBuilder(StudentLogMapBuilder.CLASS_NAME);
    }

      /** the column name for the STUDENTLOGID field */
    public static final String STUDENTLOGID;
      /** the column name for the ACTION field */
    public static final String ACTION;
      /** the column name for the YEAR field */
    public static final String YEAR;
      /** the column name for the MONTH field */
    public static final String MONTH;
      /** the column name for the DAY field */
    public static final String DAY;
      /** the column name for the HOUR field */
    public static final String HOUR;
      /** the column name for the MINUTE field */
    public static final String MINUTE;
      /** the column name for the SECOND field */
    public static final String SECOND;
      /** the column name for the STUDENTNUMBER field */
    public static final String STUDENTNUMBER;
      /** the column name for the FIRSTNAME field */
    public static final String FIRSTNAME;
      /** the column name for the MIDDLENAME field */
    public static final String MIDDLENAME;
      /** the column name for the LASTNAME field */
    public static final String LASTNAME;
      /** the column name for the SEX field */
    public static final String SEX;
      /** the column name for the BIRTHDATE field */
    public static final String BIRTHDATE;
      /** the column name for the CIVILSTATUS field */
    public static final String CIVILSTATUS;
      /** the column name for the RESIDENTIALADDRESS field */
    public static final String RESIDENTIALADDRESS;
      /** the column name for the COLLEGEADDRESS field */
    public static final String COLLEGEADDRESS;
      /** the column name for the FATHER field */
    public static final String FATHER;
      /** the column name for the MOTHER field */
    public static final String MOTHER;
      /** the column name for the GUARDIAN field */
    public static final String GUARDIAN;
      /** the column name for the GUARDIANCONTACTNUMBER field */
    public static final String GUARDIANCONTACTNUMBER;
      /** the column name for the GUARDIANADDRESS field */
    public static final String GUARDIANADDRESS;
      /** the column name for the GUARDIANRELATION field */
    public static final String GUARDIANRELATION;
      /** the column name for the GUARDIANEMAIL field */
    public static final String GUARDIANEMAIL;
      /** the column name for the ISRGEP field */
    public static final String ISRGEP;
      /** the column name for the ZIPCODE field */
    public static final String ZIPCODE;
      /** the column name for the TELEPHONENUMBER field */
    public static final String TELEPHONENUMBER;
      /** the column name for the CELLPHONENUMBER field */
    public static final String CELLPHONENUMBER;
      /** the column name for the HIGHSCHOOL field */
    public static final String HIGHSCHOOL;
      /** the column name for the HIGHSCHOOLGRADE field */
    public static final String HIGHSCHOOLGRADE;
      /** the column name for the EMAIL field */
    public static final String EMAIL;
      /** the column name for the STFAPBRACKET field */
    public static final String STFAPBRACKET;
      /** the column name for the SIGNATURE field */
    public static final String SIGNATURE;
      /** the column name for the ADVISER field */
    public static final String ADVISER;
      /** the column name for the CITIZENSHIP field */
    public static final String CITIZENSHIP;
      /** the column name for the COUNTRY field */
    public static final String COUNTRY;
      /** the column name for the CURRICULUMCODE field */
    public static final String CURRICULUMCODE;
      /** the column name for the PHOTO field */
    public static final String PHOTO;
  
    static
    {
          STUDENTLOGID = "student_log.STUDENTLOGID";
          ACTION = "student_log.ACTION";
          YEAR = "student_log.YEAR";
          MONTH = "student_log.MONTH";
          DAY = "student_log.DAY";
          HOUR = "student_log.HOUR";
          MINUTE = "student_log.MINUTE";
          SECOND = "student_log.SECOND";
          STUDENTNUMBER = "student_log.STUDENTNUMBER";
          FIRSTNAME = "student_log.FIRSTNAME";
          MIDDLENAME = "student_log.MIDDLENAME";
          LASTNAME = "student_log.LASTNAME";
          SEX = "student_log.SEX";
          BIRTHDATE = "student_log.BIRTHDATE";
          CIVILSTATUS = "student_log.CIVILSTATUS";
          RESIDENTIALADDRESS = "student_log.RESIDENTIALADDRESS";
          COLLEGEADDRESS = "student_log.COLLEGEADDRESS";
          FATHER = "student_log.FATHER";
          MOTHER = "student_log.MOTHER";
          GUARDIAN = "student_log.GUARDIAN";
          GUARDIANCONTACTNUMBER = "student_log.GUARDIANCONTACTNUMBER";
          GUARDIANADDRESS = "student_log.GUARDIANADDRESS";
          GUARDIANRELATION = "student_log.GUARDIANRELATION";
          GUARDIANEMAIL = "student_log.GUARDIANEMAIL";
          ISRGEP = "student_log.ISRGEP";
          ZIPCODE = "student_log.ZIPCODE";
          TELEPHONENUMBER = "student_log.TELEPHONENUMBER";
          CELLPHONENUMBER = "student_log.CELLPHONENUMBER";
          HIGHSCHOOL = "student_log.HIGHSCHOOL";
          HIGHSCHOOLGRADE = "student_log.HIGHSCHOOLGRADE";
          EMAIL = "student_log.EMAIL";
          STFAPBRACKET = "student_log.STFAPBRACKET";
          SIGNATURE = "student_log.SIGNATURE";
          ADVISER = "student_log.ADVISER";
          CITIZENSHIP = "student_log.CITIZENSHIP";
          COUNTRY = "student_log.COUNTRY";
          CURRICULUMCODE = "student_log.CURRICULUMCODE";
          PHOTO = "student_log.PHOTO";
          if (Torque.isInit())
        {
            try
            {
                getMapBuilder(StudentLogMapBuilder.CLASS_NAME);
            }
            catch (Exception e)
            {
                log.error("Could not initialize Peer", e);
            }
        }
        else
        {
            Torque.registerMapBuilder(StudentLogMapBuilder.CLASS_NAME);
        }
    }
 
    /** number of columns for this peer */
    public static final int numColumns =  38;

    /** A class that can be returned by this peer. */
    protected static final String CLASSNAME_DEFAULT =
        "registnet.dao.StudentLog";

    /** A class that can be returned by this peer. */
    protected static final Class CLASS_DEFAULT = initClass(CLASSNAME_DEFAULT);

    /**
     * Class object initialization method.
     *
     * @param className name of the class to initialize
     * @return the initialized class
     */
    private static Class initClass(String className)
    {
        Class c = null;
        try
        {
            c = Class.forName(className);
        }
        catch (Throwable t)
        {
            log.error("A FATAL ERROR has occurred which should not "
                + "have happened under any circumstance.  Please notify "
                + "the Torque developers <torque-dev@db.apache.org> "
                + "and give as many details as possible (including the error "
                + "stack trace).", t);

            // Error objects should always be propogated.
            if (t instanceof Error)
            {
                throw (Error) t.fillInStackTrace();
            }
        }
        return c;
    }

    /**
     * Get the list of objects for a ResultSet.  Please not that your
     * resultset MUST return columns in the right order.  You can use
     * getFieldNames() in BaseObject to get the correct sequence.
     *
     * @param results the ResultSet
     * @return the list of objects
     * @throws TorqueException Any exceptions caught during processing will be
     *         rethrown wrapped into a TorqueException.
     */
    public static List resultSet2Objects(java.sql.ResultSet results)
            throws TorqueException
    {
        try
        {
            QueryDataSet qds = null;
            List rows = null;
            try
            {
                qds = new QueryDataSet(results);
                rows = getSelectResults(qds);
            }
            finally
            {
                if (qds != null)
                {
                    qds.close();
                }
            }

            return populateObjects(rows);
        }
        catch (SQLException e)
        {
            throw new TorqueException(e);
        }
        catch (DataSetException e)
        {
            throw new TorqueException(e);
        }
    }


  
    /**
     * Method to do inserts.
     *
     * @param criteria object used to create the INSERT statement.
     * @throws TorqueException Any exceptions caught during processing will be
     *         rethrown wrapped into a TorqueException.
     */
    public static ObjectKey doInsert(Criteria criteria)
        throws TorqueException
    {
        return BaseStudentLogPeer
            .doInsert(criteria, (Connection) null);
    }

    /**
     * Method to do inserts.  This method is to be used during a transaction,
     * otherwise use the doInsert(Criteria) method.  It will take care of
     * the connection details internally.
     *
     * @param criteria object used to create the INSERT statement.
     * @param con the connection to use
     * @throws TorqueException Any exceptions caught during processing will be
     *         rethrown wrapped into a TorqueException.
     */
    public static ObjectKey doInsert(Criteria criteria, Connection con)
        throws TorqueException
    {
                                                                                                                                                                                                                                      
        // Set the correct dbName if it has not been overridden
        // criteria.getDbName will return the same object if not set to
        // another value so == check is okay and faster
        if (criteria.getDbName() == Torque.getDefaultDB())
        {
            criteria.setDbName(DATABASE_NAME);
        }
        if (con == null)
        {
            return BasePeer.doInsert(criteria);
        }
        else
        {
            return BasePeer.doInsert(criteria, con);
        }
    }

    /**
     * Add all the columns needed to create a new object.
     *
     * @param criteria object containing the columns to add.
     * @throws TorqueException Any exceptions caught during processing will be
     *         rethrown wrapped into a TorqueException.
     */
    public static void addSelectColumns(Criteria criteria)
            throws TorqueException
    {
          criteria.addSelectColumn(STUDENTLOGID);
          criteria.addSelectColumn(ACTION);
          criteria.addSelectColumn(YEAR);
          criteria.addSelectColumn(MONTH);
          criteria.addSelectColumn(DAY);
          criteria.addSelectColumn(HOUR);
          criteria.addSelectColumn(MINUTE);
          criteria.addSelectColumn(SECOND);
          criteria.addSelectColumn(STUDENTNUMBER);
          criteria.addSelectColumn(FIRSTNAME);
          criteria.addSelectColumn(MIDDLENAME);
          criteria.addSelectColumn(LASTNAME);
          criteria.addSelectColumn(SEX);
          criteria.addSelectColumn(BIRTHDATE);
          criteria.addSelectColumn(CIVILSTATUS);
          criteria.addSelectColumn(RESIDENTIALADDRESS);
          criteria.addSelectColumn(COLLEGEADDRESS);
          criteria.addSelectColumn(FATHER);
          criteria.addSelectColumn(MOTHER);
          criteria.addSelectColumn(GUARDIAN);
          criteria.addSelectColumn(GUARDIANCONTACTNUMBER);
          criteria.addSelectColumn(GUARDIANADDRESS);
          criteria.addSelectColumn(GUARDIANRELATION);
          criteria.addSelectColumn(GUARDIANEMAIL);
          criteria.addSelectColumn(ISRGEP);
          criteria.addSelectColumn(ZIPCODE);
          criteria.addSelectColumn(TELEPHONENUMBER);
          criteria.addSelectColumn(CELLPHONENUMBER);
          criteria.addSelectColumn(HIGHSCHOOL);
          criteria.addSelectColumn(HIGHSCHOOLGRADE);
          criteria.addSelectColumn(EMAIL);
          criteria.addSelectColumn(STFAPBRACKET);
          criteria.addSelectColumn(SIGNATURE);
          criteria.addSelectColumn(ADVISER);
          criteria.addSelectColumn(CITIZENSHIP);
          criteria.addSelectColumn(COUNTRY);
          criteria.addSelectColumn(CURRICULUMCODE);
          criteria.addSelectColumn(PHOTO);
      }

    /**
     * Create a new object of type cls from a resultset row starting
     * from a specified offset.  This is done so that you can select
     * other rows than just those needed for this object.  You may
     * for example want to create two objects from the same row.
     *
     * @throws TorqueException Any exceptions caught during processing will be
     *         rethrown wrapped into a TorqueException.
     */
    public static StudentLog row2Object(Record row,
                                             int offset,
                                             Class cls)
        throws TorqueException
    {
        try
        {
            StudentLog obj = (StudentLog) cls.newInstance();
            StudentLogPeer.populateObject(row, offset, obj);
                  obj.setModified(false);
              obj.setNew(false);

            return obj;
        }
        catch (InstantiationException e)
        {
            throw new TorqueException(e);
        }
        catch (IllegalAccessException e)
        {
            throw new TorqueException(e);
        }
    }

    /**
     * Populates an object from a resultset row starting
     * from a specified offset.  This is done so that you can select
     * other rows than just those needed for this object.  You may
     * for example want to create two objects from the same row.
     *
     * @throws TorqueException Any exceptions caught during processing will be
     *         rethrown wrapped into a TorqueException.
     */
    public static void populateObject(Record row,
                                      int offset,
                                      StudentLog obj)
        throws TorqueException
    {
        try
        {
                obj.setStudentLogId(row.getValue(offset + 0).asInt());
                  obj.setAction(row.getValue(offset + 1).asInt());
                  obj.setYear(row.getValue(offset + 2).asInt());
                  obj.setMonth(row.getValue(offset + 3).asInt());
                  obj.setDay(row.getValue(offset + 4).asInt());
                  obj.setHour(row.getValue(offset + 5).asInt());
                  obj.setMinute(row.getValue(offset + 6).asString());
                  obj.setSecond(row.getValue(offset + 7).asString());
                  obj.setStudentNumber(row.getValue(offset + 8).asString());
                  obj.setFirstName(row.getValue(offset + 9).asString());
                  obj.setMiddleName(row.getValue(offset + 10).asString());
                  obj.setLastName(row.getValue(offset + 11).asString());
                  obj.setSex(row.getValue(offset + 12).asString());
                  obj.setBirthDate(row.getValue(offset + 13).asString());
                  obj.setCivilStatus(row.getValue(offset + 14).asInt());
                  obj.setResidentialAddress(row.getValue(offset + 15).asString());
                  obj.setCollegeAddress(row.getValue(offset + 16).asString());
                  obj.setFather(row.getValue(offset + 17).asString());
                  obj.setMother(row.getValue(offset + 18).asString());
                  obj.setGuardian(row.getValue(offset + 19).asString());
                  obj.setGuardianContactNumber(row.getValue(offset + 20).asString());
                  obj.setGuardianAddress(row.getValue(offset + 21).asString());
                  obj.setGuardianRelation(row.getValue(offset + 22).asString());
                  obj.setGuardianEmail(row.getValue(offset + 23).asString());
                  obj.setIsRGEP(row.getValue(offset + 24).asInt());
                  obj.setZipcode(row.getValue(offset + 25).asInt());
                  obj.setTelephoneNumber(row.getValue(offset + 26).asString());
                  obj.setCellphoneNumber(row.getValue(offset + 27).asString());
                  obj.setHighSchool(row.getValue(offset + 28).asString());
                  obj.setHighSchoolGrade(row.getValue(offset + 29).asDouble());
                  obj.setEmail(row.getValue(offset + 30).asString());
                  obj.setSTFAPBracket(row.getValue(offset + 31).asInt());
                  obj.setSignature(row.getValue(offset + 32).asBytes());
                  obj.setAdviser(row.getValue(offset + 33).asString());
                  obj.setCitizenship(row.getValue(offset + 34).asInt());
                  obj.setCountry(row.getValue(offset + 35).asString());
                  obj.setCurriculumCode(row.getValue(offset + 36).asString());
                  obj.setPhoto(row.getValue(offset + 37).asBytes());
              }
        catch (DataSetException e)
        {
            throw new TorqueException(e);
        }
    }

    /**
     * Method to do selects.
     *
     * @param criteria object used to create the SELECT statement.
     * @return List of selected Objects
     * @throws TorqueException Any exceptions caught during processing will be
     *         rethrown wrapped into a TorqueException.
     */
    public static List doSelect(Criteria criteria) throws TorqueException
    {
        return populateObjects(doSelectVillageRecords(criteria));
    }

    /**
     * Method to do selects within a transaction.
     *
     * @param criteria object used to create the SELECT statement.
     * @param con the connection to use
     * @return List of selected Objects
     * @throws TorqueException Any exceptions caught during processing will be
     *         rethrown wrapped into a TorqueException.
     */
    public static List doSelect(Criteria criteria, Connection con)
        throws TorqueException
    {
        return populateObjects(doSelectVillageRecords(criteria, con));
    }

    /**
     * Grabs the raw Village records to be formed into objects.
     * This method handles connections internally.  The Record objects
     * returned by this method should be considered readonly.  Do not
     * alter the data and call save(), your results may vary, but are
     * certainly likely to result in hard to track MT bugs.
     *
     * @throws TorqueException Any exceptions caught during processing will be
     *         rethrown wrapped into a TorqueException.
     */
    public static List doSelectVillageRecords(Criteria criteria)
        throws TorqueException
    {
        return BaseStudentLogPeer
            .doSelectVillageRecords(criteria, (Connection) null);
    }

    /**
     * Grabs the raw Village records to be formed into objects.
     * This method should be used for transactions
     *
     * @param con the connection to use
     * @throws TorqueException Any exceptions caught during processing will be
     *         rethrown wrapped into a TorqueException.
     */
    public static List doSelectVillageRecords(Criteria criteria, Connection con)
        throws TorqueException
    {
        if (criteria.getSelectColumns().size() == 0)
        {
            addSelectColumns(criteria);
        }

                                                                                                                                                                                                                                      
        // Set the correct dbName if it has not been overridden
        // criteria.getDbName will return the same object if not set to
        // another value so == check is okay and faster
        if (criteria.getDbName() == Torque.getDefaultDB())
        {
            criteria.setDbName(DATABASE_NAME);
        }
        // BasePeer returns a List of Value (Village) arrays.  The array
        // order follows the order columns were placed in the Select clause.
        if (con == null)
        {
            return BasePeer.doSelect(criteria);
        }
        else
        {
            return BasePeer.doSelect(criteria, con);
        }
    }

    /**
     * The returned List will contain objects of the default type or
     * objects that inherit from the default.
     *
     * @throws TorqueException Any exceptions caught during processing will be
     *         rethrown wrapped into a TorqueException.
     */
    public static List populateObjects(List records)
        throws TorqueException
    {
        List results = new ArrayList(records.size());

        // populate the object(s)
        for (int i = 0; i < records.size(); i++)
        {
            Record row = (Record) records.get(i);
              results.add(StudentLogPeer.row2Object(row, 1,
                StudentLogPeer.getOMClass()));
          }
        return results;
    }
 

    /**
     * The class that the Peer will make instances of.
     * If the BO is abstract then you must implement this method
     * in the BO.
     *
     * @throws TorqueException Any exceptions caught during processing will be
     *         rethrown wrapped into a TorqueException.
     */
    public static Class getOMClass()
        throws TorqueException
    {
        return CLASS_DEFAULT;
    }

    /**
     * Method to do updates.
     *
     * @param criteria object containing data that is used to create the UPDATE
     *        statement.
     * @throws TorqueException Any exceptions caught during processing will be
     *         rethrown wrapped into a TorqueException.
     */
    public static void doUpdate(Criteria criteria) throws TorqueException
    {
         BaseStudentLogPeer
            .doUpdate(criteria, (Connection) null);
    }

    /**
     * Method to do updates.  This method is to be used during a transaction,
     * otherwise use the doUpdate(Criteria) method.  It will take care of
     * the connection details internally.
     *
     * @param criteria object containing data that is used to create the UPDATE
     *        statement.
     * @param con the connection to use
     * @throws TorqueException Any exceptions caught during processing will be
     *         rethrown wrapped into a TorqueException.
     */
    public static void doUpdate(Criteria criteria, Connection con)
        throws TorqueException
    {
        Criteria selectCriteria = new Criteria(DATABASE_NAME, 2);
                   selectCriteria.put(STUDENTLOGID, criteria.remove(STUDENTLOGID));
                                                                                                                                                                                                                                                                                                                                                                                        
        // Set the correct dbName if it has not been overridden
        // criteria.getDbName will return the same object if not set to
        // another value so == check is okay and faster
        if (criteria.getDbName() == Torque.getDefaultDB())
        {
            criteria.setDbName(DATABASE_NAME);
        }
        if (con == null)
        {
            BasePeer.doUpdate(selectCriteria, criteria);
        }
        else
        {
            BasePeer.doUpdate(selectCriteria, criteria, con);
        }
    }

    /**
     * Method to do deletes.
     *
     * @param criteria object containing data that is used DELETE from database.
     * @throws TorqueException Any exceptions caught during processing will be
     *         rethrown wrapped into a TorqueException.
     */
     public static void doDelete(Criteria criteria) throws TorqueException
     {
         BaseStudentLogPeer
            .doDelete(criteria, (Connection) null);
     }

    /**
     * Method to do deletes.  This method is to be used during a transaction,
     * otherwise use the doDelete(Criteria) method.  It will take care of
     * the connection details internally.
     *
     * @param criteria object containing data that is used DELETE from database.
     * @param con the connection to use
     * @throws TorqueException Any exceptions caught during processing will be
     *         rethrown wrapped into a TorqueException.
     */
     public static void doDelete(Criteria criteria, Connection con)
        throws TorqueException
     {
                                                                                                                                                                                                                                      
        // Set the correct dbName if it has not been overridden
        // criteria.getDbName will return the same object if not set to
        // another value so == check is okay and faster
        if (criteria.getDbName() == Torque.getDefaultDB())
        {
            criteria.setDbName(DATABASE_NAME);
        }
        if (con == null)
        {
            BasePeer.doDelete(criteria);
        }
        else
        {
            BasePeer.doDelete(criteria, con);
        }
     }

    /**
     * Method to do selects
     *
     * @throws TorqueException Any exceptions caught during processing will be
     *         rethrown wrapped into a TorqueException.
     */
    public static List doSelect(StudentLog obj) throws TorqueException
    {
        return doSelect(buildCriteria(obj));
    }

    /**
     * Method to do inserts
     *
     * @throws TorqueException Any exceptions caught during processing will be
     *         rethrown wrapped into a TorqueException.
     */
    public static void doInsert(StudentLog obj) throws TorqueException
    {
          obj.setPrimaryKey(doInsert(buildCriteria(obj)));
          obj.setNew(false);
        obj.setModified(false);
    }

    /**
     * @param obj the data object to update in the database.
     * @throws TorqueException Any exceptions caught during processing will be
     *         rethrown wrapped into a TorqueException.
     */
    public static void doUpdate(StudentLog obj) throws TorqueException
    {
        doUpdate(buildCriteria(obj));
        obj.setModified(false);
    }

    /**
     * @param obj the data object to delete in the database.
     * @throws TorqueException Any exceptions caught during processing will be
     *         rethrown wrapped into a TorqueException.
     */
    public static void doDelete(StudentLog obj) throws TorqueException
    {
        doDelete(buildCriteria(obj));
    }

    /**
     * Method to do inserts.  This method is to be used during a transaction,
     * otherwise use the doInsert(StudentLog) method.  It will take
     * care of the connection details internally.
     *
     * @param obj the data object to insert into the database.
     * @param con the connection to use
     * @throws TorqueException Any exceptions caught during processing will be
     *         rethrown wrapped into a TorqueException.
     */
    public static void doInsert(StudentLog obj, Connection con)
        throws TorqueException
    {
          obj.setPrimaryKey(doInsert(buildCriteria(obj), con));
          obj.setNew(false);
        obj.setModified(false);
    }

    /**
     * Method to do update.  This method is to be used during a transaction,
     * otherwise use the doUpdate(StudentLog) method.  It will take
     * care of the connection details internally.
     *
     * @param obj the data object to update in the database.
     * @param con the connection to use
     * @throws TorqueException Any exceptions caught during processing will be
     *         rethrown wrapped into a TorqueException.
     */
    public static void doUpdate(StudentLog obj, Connection con)
        throws TorqueException
    {
        doUpdate(buildCriteria(obj), con);
        obj.setModified(false);
    }

    /**
     * Method to delete.  This method is to be used during a transaction,
     * otherwise use the doDelete(StudentLog) method.  It will take
     * care of the connection details internally.
     *
     * @param obj the data object to delete in the database.
     * @param con the connection to use
     * @throws TorqueException Any exceptions caught during processing will be
     *         rethrown wrapped into a TorqueException.
     */
    public static void doDelete(StudentLog obj, Connection con)
        throws TorqueException
    {
        doDelete(buildCriteria(obj), con);
    }

    /**
     * Method to do deletes.
     *
     * @param pk ObjectKey that is used DELETE from database.
     * @throws TorqueException Any exceptions caught during processing will be
     *         rethrown wrapped into a TorqueException.
     */
    public static void doDelete(ObjectKey pk) throws TorqueException
    {
        BaseStudentLogPeer
           .doDelete(pk, (Connection) null);
    }

    /**
     * Method to delete.  This method is to be used during a transaction,
     * otherwise use the doDelete(ObjectKey) method.  It will take
     * care of the connection details internally.
     *
     * @param pk the primary key for the object to delete in the database.
     * @param con the connection to use
     * @throws TorqueException Any exceptions caught during processing will be
     *         rethrown wrapped into a TorqueException.
     */
    public static void doDelete(ObjectKey pk, Connection con)
        throws TorqueException
    {
        doDelete(buildCriteria(pk), con);
    }

    /** Build a Criteria object from an ObjectKey */
    public static Criteria buildCriteria( ObjectKey pk )
    {
        Criteria criteria = new Criteria();
              criteria.add(STUDENTLOGID, pk);
          return criteria;
     }

    /** Build a Criteria object from the data object for this peer */
    public static Criteria buildCriteria( StudentLog obj )
    {
        Criteria criteria = new Criteria(DATABASE_NAME);
              if (!obj.isNew())
                criteria.add(STUDENTLOGID, obj.getStudentLogId());
                  criteria.add(ACTION, obj.getAction());
                  criteria.add(YEAR, obj.getYear());
                  criteria.add(MONTH, obj.getMonth());
                  criteria.add(DAY, obj.getDay());
                  criteria.add(HOUR, obj.getHour());
                  criteria.add(MINUTE, obj.getMinute());
                  criteria.add(SECOND, obj.getSecond());
                  criteria.add(STUDENTNUMBER, obj.getStudentNumber());
                  criteria.add(FIRSTNAME, obj.getFirstName());
                  criteria.add(MIDDLENAME, obj.getMiddleName());
                  criteria.add(LASTNAME, obj.getLastName());
                  criteria.add(SEX, obj.getSex());
                  criteria.add(BIRTHDATE, obj.getBirthDate());
                  criteria.add(CIVILSTATUS, obj.getCivilStatus());
                  criteria.add(RESIDENTIALADDRESS, obj.getResidentialAddress());
                  criteria.add(COLLEGEADDRESS, obj.getCollegeAddress());
                  criteria.add(FATHER, obj.getFather());
                  criteria.add(MOTHER, obj.getMother());
                  criteria.add(GUARDIAN, obj.getGuardian());
                  criteria.add(GUARDIANCONTACTNUMBER, obj.getGuardianContactNumber());
                  criteria.add(GUARDIANADDRESS, obj.getGuardianAddress());
                  criteria.add(GUARDIANRELATION, obj.getGuardianRelation());
                  criteria.add(GUARDIANEMAIL, obj.getGuardianEmail());
                  criteria.add(ISRGEP, obj.getIsRGEP());
                  criteria.add(ZIPCODE, obj.getZipcode());
                  criteria.add(TELEPHONENUMBER, obj.getTelephoneNumber());
                  criteria.add(CELLPHONENUMBER, obj.getCellphoneNumber());
                  criteria.add(HIGHSCHOOL, obj.getHighSchool());
                  criteria.add(HIGHSCHOOLGRADE, obj.getHighSchoolGrade());
                  criteria.add(EMAIL, obj.getEmail());
                  criteria.add(STFAPBRACKET, obj.getSTFAPBracket());
                  criteria.add(SIGNATURE, obj.getSignature());
                  criteria.add(ADVISER, obj.getAdviser());
                  criteria.add(CITIZENSHIP, obj.getCitizenship());
                  criteria.add(COUNTRY, obj.getCountry());
                  criteria.add(CURRICULUMCODE, obj.getCurriculumCode());
                  criteria.add(PHOTO, obj.getPhoto());
          return criteria;
    }
 
    
        /**
     * Retrieve a single object by pk
     *
     * @param pk the primary key
     * @throws TorqueException Any exceptions caught during processing will be
     *         rethrown wrapped into a TorqueException.
     * @throws NoRowsException Primary key was not found in database.
     * @throws TooManyRowsException Primary key was not found in database.
     */
    public static StudentLog retrieveByPK(int pk)
        throws TorqueException, NoRowsException, TooManyRowsException
    {
        return retrieveByPK(SimpleKey.keyFor(pk));
    }
  
    /**
     * Retrieve a single object by pk
     *
     * @param pk the primary key
     * @throws TorqueException Any exceptions caught during processing will be
     *         rethrown wrapped into a TorqueException.
     * @throws NoRowsException Primary key was not found in database.
     * @throws TooManyRowsException Primary key was not found in database.
     */
    public static StudentLog retrieveByPK(ObjectKey pk)
        throws TorqueException, NoRowsException, TooManyRowsException
    {
        Connection db = null;
        StudentLog retVal = null;
        try
        {
            db = Torque.getConnection(DATABASE_NAME);
            retVal = retrieveByPK(pk, db);
        }
        finally
        {
            Torque.closeConnection(db);
        }
        return(retVal);
    }

    /**
     * Retrieve a single object by pk
     *
     * @param pk the primary key
     * @param con the connection to use
     * @throws TorqueException Any exceptions caught during processing will be
     *         rethrown wrapped into a TorqueException.
     * @throws NoRowsException Primary key was not found in database.
     * @throws TooManyRowsException Primary key was not found in database.
     */
    public static StudentLog retrieveByPK(ObjectKey pk, Connection con)
        throws TorqueException, NoRowsException, TooManyRowsException
    {
        Criteria criteria = buildCriteria(pk);
        List v = doSelect(criteria, con);
        if (v.size() == 0)
        {
            throw new NoRowsException("Failed to select a row.");
        }
        else if (v.size() > 1)
        {
            throw new TooManyRowsException("Failed to select only one row.");
        }
        else
        {
            return (StudentLog)v.get(0);
        }
    }

    /**
     * Retrieve a multiple objects by pk
     *
     * @param pks List of primary keys
     * @throws TorqueException Any exceptions caught during processing will be
     *         rethrown wrapped into a TorqueException.
     */
    public static List retrieveByPKs(List pks)
        throws TorqueException
    {
        Connection db = null;
        List retVal = null;
        try
        {
           db = Torque.getConnection(DATABASE_NAME);
           retVal = retrieveByPKs(pks, db);
        }
        finally
        {
            Torque.closeConnection(db);
        }
        return(retVal);
    }

    /**
     * Retrieve a multiple objects by pk
     *
     * @param pks List of primary keys
     * @param dbcon the connection to use
     * @throws TorqueException Any exceptions caught during processing will be
     *         rethrown wrapped into a TorqueException.
     */
    public static List retrieveByPKs( List pks, Connection dbcon )
        throws TorqueException
    {
        List objs = null;
        if (pks == null || pks.size() == 0)
        {
            objs = new LinkedList();
        }
        else
        {
            Criteria criteria = new Criteria();
              criteria.addIn( STUDENTLOGID, pks );
          objs = doSelect(criteria, dbcon);
        }
        return objs;
    }

 



        
  
  
    
  
      /**
     * Returns the TableMap related to this peer.  This method is not
     * needed for general use but a specific application could have a need.
     *
     * @throws TorqueException Any exceptions caught during processing will be
     *         rethrown wrapped into a TorqueException.
     */
    protected static TableMap getTableMap()
        throws TorqueException
    {
        return Torque.getDatabaseMap(DATABASE_NAME).getTable(TABLE_NAME);
    }
   }
